Show AllSome of the content in this topic may not be applicable to some languages.
I can't find the Euro Conversion command or button.
If you don't see the Euro Conversion command on the Tools menu, click Add-Ins on the Tools menu, and then select the Euro Currency Tools check box to load the add-in program.
If Euro Currency Tools isn't listed in the Add-Ins dialog box, you must install the add-in program, then return to the Add-Ins dialog box and select the Euro Currency Tools check box to load the add-in program.
If you originally installed your Microsoft Office program from a network file server or from a shared folder, you must install or remove components from that location. If you installed your Office program from a CD-ROM and you've mapped your CD-ROM drive to a new drive letter since installing the Office program, reinstall from the CD-ROM. If you're running any Office program files from the CD-ROM, you must uninstall the Office program and then reinstall it from the CD-ROM.
Quit all programs.
Double-click the Add/Remove Programs icon in the Windows Control Panel.
Do one of the following:
For Windows 2000 and Windows Millennium Edition:
If you installed your Office program as part of Microsoft Office, click Microsoft Office in the Currently installed programs box, and then click the Change button.
If you installed your Office program individually, click the name of your program in the Currently installed programs box, and then click the Change button.
For Windows 98 and Windows NT 4.0:
If you installed your Office program as part of Microsoft Office, click Microsoft Office on the Install/Uninstall tab, and then click the Add/Remove button.
If you installed your Office program individually, click the name of your program on the Install/Uninstall tab, and then click the Add/Remove button.
Follow the instructions on the screen.
Values were copied but not converted.
The Euro Conversion tool converts numbers only. Text that Microsoft Excel cannot interpret as a number (such as alphanumeric text) and numbers formatted as dates are copied but not converted. Make sure the values you are trying to convert are numbers that are not formatted as dates.
My formulas disappear or are changed.
When you convert formulas using the Euro Conversion tool, the default setting is to convert the formulas to values. You can use the options in the Advanced dialog box (click Advanced in the Euro Conversion dialog box) to change how formulas are converted. Use Prompt to convert formulas for more options for each formula.
The EUROCONVERT function uses the European Union rates, or conversion factors, that express one euro in each of the euro member national currency units. Each conversion factor has six significant digits.
If you don't want rounding to occur, set Full_Precision to TRUE, and make sure the number format for the cell isn't currency.
The EuroValue toolbar is blank, displays "Off," or does not show my converted values correctly.
The EuroValue toolbar shows different results depending on:
Conversion list set to Off If you click the arrow next to the box on the right side of the EuroValue toolbar, and click Off, the toolbar remains on your screen but displays the word Off rather than a converted value. To see a converted value in the toolbar, click the arrow next to the box that displays the word Off, and then click the desired conversion from the list.
Range of cells selected When you select more than one cell that contains numbers, the value shown in the EuroValue toolbar is the converted sum of the numbers. If you don't want to see a sum, select an individual cell instead.
Text selected The EuroValue toolbar may show a zero value if you select cells that contain text. Select cells that contain currency values instead.
Dates or times selected If the cell you select contains a date or time, the tool converts the serial number of the date or time. Select a cell that contains a currency value instead.
Hidden cells selected If the cells you select contain hidden columns or rows, the result shown in the EuroValue toolbar includes the values in the hidden cells. If you do not want these values to be included in the converted sum, select the individual cells you do want included by holding down the CTRL key while you click each one. Or, unhide the hidden rows or columns and move them elsewhere on the worksheet.
Toolbar is redisplayed When the conversion value list in the EuroValue toolbar is not set to Off, the toolbar updates when the toolbar is displayed and you click on a cell or range of cells, and when you click a conversion value from the box on the right side of the toolbar. If you hide the EuroValue toolbar, select different cells, and then redisplay the toolbar, the EuroValue toolbar will show the values resulting from the cells previously selected. To update the toolbar to reflect conversion values for the currently selected cells, select a cell other than the cells for which you want to see converted values, and then reselect the cells for which you want to see converted values.
Euro conversions look different on another computer.
For euro conversions to calculate properly, the Euro Currency Tools add-in program must be installed on the computer you are using, and you must be using the appropriate version of Microsoft Excel.
Also, your operating system must support the euro sign. For example, if you have Microsoft Windows NT 4.0 with Service Pack 3 or earlier, you may need to download the Microsoft Euro Currency Support product update to input and display the euro sign in programs that support the euro sign. For more information, see the Microsoft Office Web site.
The currency I want to convert from or to isn't listed.
The Microsoft Excel Euro Currency Tools add-in program provides tools to work with euros and the national currency units of the European Union (EU) members that have adopted the euro. The tools do not convert currencies of non-euro-member countries/regions. As additional countries or regions adopt the euro, Microsoft makes updates to the tools available. If you do not see the national currency you want in the list, check to make sure the country or region is a euro member state, and if it is, check for an updated version of the tools on the Microsoft Office Web site.
I converted or formatted values and Undo is not available.
After you convert values to or from the euro or to another euro member currency, or after you format values as euros, neither the Undo command nor the Undo button are available. To return your workbook to its previous state, close the workbook without saving changes. However, any other changes you made since your last save will also be lost.
I converted several values, and some values don't look right.
The source range you specified may contain times or dates. The Euro Conversion tool converts all numbers, including the serial numbers of times and the serial numbers of dates that are formatted with the General format (so that the serial number of the date is displayed). Numbers formatted as dates are copied but not converted. When you specify the source range you want to convert, make sure the range does not contain times or dates that are not formatted as dates.
I converted some values but the currency format is wrong.
Output format The output format in the Euro Conversion dialog box may not be set for the formatting you want. Click Euro Conversion again, and check to make sure the proper format is selected in the Output format box.
Microsoft Windows Control Panel The regional settings for currency in Microsoft Windows Control Panel determine the position of the euro sign 
(that is, whether the symbol appears before or after the number and whether a space separates the symbol and the number). To change this positioning, create a Custom currency style.
Microsoft Windows NT 4.0 If you have Windows NT 4.0, you may need to download the Euro Currency Support product update to input and display the euro sign in programs that support the euro sign. For more information, see the Microsoft Office Web site.
I imported or exported a text file, and currencies are not shown correctly.
Importing When you import text files into Microsoft Excel, Excel recognizes only the currency symbol that is designated by the regional settings in Windows Control Panel, and the euro sign. When you import a file and want to show national currencies other than the default or euro currencies, you can create custom number formats and apply the desired formats to the values you want after the file is imported. To keep your changes, save the file as an Excel workbook.
Exporting When you save a workbook in one of the following file formats, the euro sign is not retained: all dBase file formats, all Lotus 1-2-3 file formats, Quattro Pro/DOS file format, Microsoft Excel 2.1 Worksheet, Microsoft Excel 3.0 Worksheet, Microsoft Excel 4.0 Worksheet, Microsoft Excel 4.0 Workbook, and Microsoft Excel 5.0/95 Workbook. The euro sign is converted to a question mark in the following file formats: CSV (MS-DOS), Text (MS-DOS), and DIF (Data Interchange Format). The euro sign is converted to an s in the following file formats: CSV (Macintosh) and Text (Macintosh). For more information, see Help for the program you're exporting to for information about how that program handles euro currency.
The euro sign does not print correctly.
Microsoft Excel and your operating system provide the support you need to print the euro sign correctly on most printers. However, the euro sign may not print correctly on some printers using some fonts. Check with your printer manufacturer for more information.
For more information about operating system support for the euro sign, see the Microsoft Office Web site.
I copied the euro sign in text from another program, but it did not paste in Microsoft Excel.
When you copy text that includes the euro sign from another program such as Microsoft Word, the euro sign is not pasted in Excel. You must reapply euro formatting or add the symbol manually to the pasted value.
I get a message about my source range.
You may not have specified a source range in the Source range box in the Euro Conversion dialog box, or you may have selected nonadjacent ranges. Be sure you have a single source range entered in the Source range box before you click OK.
I get a message about the destination range.
Specify a single rectangular destination range You may not have specified a destination range in the Destination range box, or you may have selected nonadjacent destination ranges. Click in the Destination range box, and then select a single cell to use as the upper left corner of the range you want to fill.
Make sure the source and destination ranges don't overlap The destination range must not include any of the cells in the source range.